Create Other Staging Table in Staging Database and Populate the Staging Tables - Continued 9

FIPS for Data Sources- Drag and drop the data Flow task – double click –

1.     Drag and drop the Flat Source – Double click and add the Flat connection manager and select the sheet from the excel to load the data

2.     Drag and drop the Conditional Split - Double click and add condition to remove the Null values 

ISNULL(Mnemonic) || ISNULL(RCA_Name) || ISNULL(Name) || ISNULL(FIPS)

3.     Drag and drop the Derived Column transformation – Add column “Check_Numeric_Value

         (DT_I4)FIPS == (DT_I4)FIPS ? 1 : 0

4.     Drag and drop the Derived Column transformation – replace Check_Numeric_Value

           ISNULL(CHECK_NUMERIC_FLAG) ? 0 :1

5.     Drag and drop the Conditional Split - Double click and add condition to remove the Null values 

 CHECK_NUMERIC_FLAG == 1

6.     Drag and drop the Data Conversion and select FIPS and change the data type to Integer.

7.     Drag and drop the OLE DB Destination – double click – add OLE DB Destination manager – select the destination table and mapping on the column to the table

 

 

FIPS For Final- Drag and drop the data Flow task – double click –

1.     Drag and drop the Flat Source – Double click and add the Flat connection manager and select the sheet from the excel to load the data

2.     Drag and drop the Conditional Split - Double click and add condition to remove the Null values 

 ISNULL(Mnemonic)|| ISNULL(CBSA)

3.     Drag and drop the Derived Column transformation – Add column “Check_Numeric_Value

         (DT_I4)CBSA == (DT_I4)CBSA ? 1 : 0

4.     Drag and drop the Derived Column transformation – replace Check_Numeric_Value

        ISNULL(CHECK_NUMERIC_FLAG) ? 0 :1

5.     Drag and drop the Conditional Split - Double click and add condition to remove the Null values 

 CHECK_NUMERIC_FLAG == 1

6.     Drag and drop the Data Conversion and select CBSA and change the data type to Integer.

7.     Drag and drop the OLE DB Destination – double click – add OLE DB Destination manager – select the destination table and mapping on the column to the table

 


FIPS For Final- Drag and drop the data Flow task – double click –

 

1.     Drag and drop the Flat Source – Double click and add the Flat connection manager and select the sheet from the excel to load the data

2.     Drag and drop the Data Conversion and select column and change the data type as in reference picture.

3.     Drag and drop the OLE DB Destination – double click – add OLE DB Destination manager – select the destination table and mapping on the column to the table

 


Populate the other  staging tables after executing the package 



continued to next step


How to load Flat file source